Listing Tools

STUNNING CONTEMPORARY DESIGN...EXCEPTIONAL CRAFTSMANSHIP COMPLETELY REIMAGINED! Prepare to be captivated by this EXTRAORDINARY, COMPLETELY RENOVATED residence, where SOPHISTICATED MODERN finishes, DRAMATIC architectural details, and THOUGHTFULLY DESIGNED living spaces come together beautifully. Meticulously transformed from top to bottom, this truly special home offers an OPEN CONCEPT FLOOR PLAN, GORGEOUS hardwood floors throughout, and an abundance of NATURAL LIGHT. The CATHEDRAL living room features a STRIKING FIREPLACE and creates an impressive first impression, flowing seamlessly into the SPECTACULAR CHEF'S kitchen. A SHOWPIECE in its own right, the kitchen boasts SLEEK CONTEMPORARY cabinetry, an OVERSIZED ISLAND, TOP-OF-THE-LINE STAINLESS STEEL appliances, a professional VENTED HOOD, and STUNNING modern finishes throughout. A STYLISH dining room or the 1st floor study offers the perfect work-from-home retreat, while a beautifully appointed half bath with a backlit mirror adds another touch of contemporary ELEGANCE. Upstairs, three FABULOUS bedrooms include a LUXURIOUS primary suite featuring a SPA-INSPIRED private bath with DOUBLE VANITIES, an OVERSIZED stone shower, and a GORGEOUS soaking tub. An additional BEAUTIFULLY finished full bath serves the remaining bedrooms. The 3rd floor offers an incredible surprise...a SPRAWLING, OPEN bonus space filled with NATURAL LIGHT from numerous SKYLIGHTS and DISTINCTIVE ARCHITECTURAL WINDOWS. Whether envisioned as a media room, game room, entertaining space, or private retreat, the possibilities are endless! Set on a LARGE, PRIVATE lot, the property also features a detached garage and an additional detached structure offering tremendous versatility. The extensive complete renovation includes NEW plumbing, HVAC, electrical, kitchen, bathrooms, flooring, paint, and so much more...providing the look, feel, and comfort of an entirely new home. Every detail has been thoughtfully considered, every space beautifully executed, and every turn reveals something special. THIS IS CONTEMPORARY LIVING AT ITS FINEST...TRULY ONE OF A KIND!

More Info

Basic Information

  • Bedrooms3
  • Mls StatusNew
  • Bathroom3
  • Lot Features Wooded, Level
  • Parcel Number 2856523
  • Road Frontage DescriptionPaved

Tax Information

  • Tax Assessed Value $695,700
  • Tax Year 2026
  • Taxes$9,106

Parking

  • Parking Spaces6
  • Covered Spaces 1
  • Garage YN Yes
  • Open Parking YN Yes
  • Parking Features Detached, Paved Drive, Off Street, Paved

Rooms

  • Bathroom 1 Main, First
  • Bathroom 2 Second
  • Bathroom 3 Second
  • Bathrooms Total Decimal 2.5
  • Bedroom 2 Second
  • Bedroom 3 Second
  • Dining Room Main, First
  • Family Room Third
  • Full Bath2
  • Half Baths1
  • Kitchen Main, First
  • Living Room Main, First
  • Main Level Bathrooms 1
  • Master Bedroom Second

Basic Information

  • List Price$895,000
  • MLS Number73601587
  • Modification Date11/12/2026
  • Property SubTypeSingle Family Residence

Location

  • Address174 Gilbert Street
  • Building Number174
  • CountyBristol
  • StateMA
  • StreetGilbert Street
  • TownMansfield
  • Zip02048

Building

  • BasementPartial, Crawl Space, Unfinished
  • Building Area Units Square Feet
  • Construction Materials Frame
  • FireplaceYes
  • Fireplace Features Living Room
  • Fireplaces Total 1
  • FoundationConcrete Perimeter
  • Garage Spaces1
  • Patio And Porch Features Porch, Deck - Wood
  • Property StyleContemporary
  • Rooms10
  • Year Built1930
  • Year Built Details Actual
  • Year Built Source Public Records

Property

  • Acreage1.2

Interior

  • Flooring Hardwood, Flooring - Hardwood
  • Interior Features Recessed Lighting, Study

Exterior

  • Exterior Features Porch, Deck - Wood, Storage
  • RoofShingle

Utilities

  • Cooling Central Air
  • Cooling YN Yes
  • Heat SystemYes
  • Heating Forced Air
  • Sewer Private Sewer
  • Water Source Public

Property Information

  • Square Feet2,699
  • Building Area Source Owner
  • Living Area 2,699
  • Lot Size Square Feet 52,272
  • Lot Size Units Acres
  • Road Responsibility Public Maintained Road

Amenities

  • AmenitiesShopping, Walk/Jog Trails, Conservation Area, Highway Access
  • Appliances IncludedRange, Dishwasher, Microwave, Refrigerator, Range Hood

Other

  • Date Listed11/12/2026
  • Farm Land Area Units Square Feet

Map Location

Driving Directions

Listed by Deborah Piazza of Coldwell Banker Realty - Sharon

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Castles Unlimited. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.